SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE [dbo].[InsertSSBDailyIncome444]
@Fund varchar(10),
@FundName varchar(100),
@AccountNumber decimal(38,10),
@SubAccountNumber DECIMAL(38,2),
@AccountName varchar(100),
@Basis varchar(100),
@ReportDateStartingBalance decimal(38,10),
@ReportDateCredits decimal(38,10),
@ReportDateDebits decimal(38,10),
@ReportDateNetAmount decimal(38,10),
@EndingLedgerBalance decimal(38,10),
@EndingLedgerBalanceDBCRInd varchar(10),
@FinancialCurrencyName varchar(10),
@FinancialStatementCurrency varchar(10),
@LocalCurrencyCode varchar(10),
@LocalCurrencyName varchar(10),
@BaseCurrencyCode varchar(10),
@BaseCurrencyName varchar(10),
@MultiCurrencyFlag varchar(10),
@PeriodEndDate date,
@PeriodStartDate date,
@PostingPeriod varchar(10),
@RealMemoIndicator varchar(10)
AS BEGIN
SET NOCOUNT ON
INSERT SSBDailyIncome
        ( 
Fund,
FundName,
AccountNumber,
SubAccountNumber,
AccountName,
Basis,
ReportDateStartingBalance,
ReportDateCredits,
ReportDateDebits,
ReportDateNetAmount,
EndingLedgerBalance,
EndingLedgerBalanceDBCRInd,
FinancialCurrencyName,
FinancialStatementCurrency,
LocalCurrencyCode,
LocalCurrencyName,
BaseCurrencyCode,
BaseCurrencyName,
MultiCurrencyFlag,
PeriodEndDate,
PeriodStartDate,
PostingPeriod,
RealMemoIndicator
)
VALUES (
@Fund,
@FundName,
@AccountNumber,
@SubAccountNumber,
@AccountName,
@Basis,
@ReportDateStartingBalance,
@ReportDateCredits,
@ReportDateDebits,
@ReportDateNetAmount,
@EndingLedgerBalance,
@EndingLedgerBalanceDBCRInd,
@FinancialCurrencyName,
@FinancialStatementCurrency,
@LocalCurrencyCode,
@LocalCurrencyName,
@BaseCurrencyCode,
@BaseCurrencyName,
@MultiCurrencyFlag,
@PeriodEndDate,
@PeriodStartDate,
@PostingPeriod,
@RealMemoIndicator
)
RETURN SCOPE_IDENTITY()
   END
GO
EXEC sp_addextendedproperty N'VirtualFolder', N'Dbo', 'SCHEMA', N'dbo', 'PROCEDURE', N'InsertSSBDailyIncome444', NULL, NULL
GO
